# Importing an Excel Weekly Status Report **URL:** \ **Category:** Flow Production Tracking\ **Tags:** importer\ **Created:** [October 22, 2024, 6:02pm UTC](https://community.shotgridsoftware.com/t/importing-an-excel-weekly-status-report/19357 "2024-10-22T18:02:38Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![zackh87](https://avatars.discourse-cdn.com/v4/letter/z/96bed5/32.png) [@zackh87](https://community.shotgridsoftware.com/u/zackh87)\ **Post date:** [October 22, 2024, 6:02pm UTC](https://community.shotgridsoftware.com/t/importing-an-excel-weekly-status-report/19357/1 "2024-10-22T18:02:38Z")
Is there a way to define a starting row within the bulk importer? Essentially I have a report where the fields don’t begin until row 6. Each time I drag the document in, Flow gets confused so being able to designate a “start point” would be awesome. ---
**Author:** ![PeteHart](https://avatars.discourse-cdn.com/v4/letter/p/a3d4f5/32.png) [@PeteHart](https://community.shotgridsoftware.com/u/PeteHart)\ **Post date:** [October 22, 2024, 6:11pm UTC](https://community.shotgridsoftware.com/t/importing-an-excel-weekly-status-report/19357/2 "2024-10-22T18:11:52Z")
Not that I’m aware of but you can just select the data you want in excel and the headers then copy and paste the data into the bulk importer. Technically you don’t need the headers either but you’ll need to define those manually during import if you don’t use them or sg can’t auto detect them ---
**Author:** ![Ricardo\_Musch](https://sea1.discourse-cdn.com/shotgunsoftware/user_avatar/community.shotgridsoftware.com/ricardo_musch/32/405_2.png) [@Ricardo\_Musch](https://community.shotgridsoftware.com/u/Ricardo_Musch)\ **Post date:** [October 23, 2024, 9:16am UTC](https://community.shotgridsoftware.com/t/importing-an-excel-weekly-status-report/19357/3 "2024-10-23T09:16:09Z")
You could try making another tab in excel that references the headers from your “pretty” tab and then references the data from the 6th row. ---
**Author:** ![Mikasonu](https://avatars.discourse-cdn.com/v4/letter/m/ecb155/32.png) [@Mikasonu](https://community.shotgridsoftware.com/u/Mikasonu)\ **Post date:** [December 19, 2024, 12:48pm UTC](https://community.shotgridsoftware.com/t/importing-an-excel-weekly-status-report/19357/4 "2024-12-19T12:48:53Z")
I’ve dealt with importing Excel weekly reports a lot, and separating dates and times can be tricky, but it’s manageable. You can use Excel’s text functions if you have the date and time in one cell and want to split them. First, to separate the date from the time, try using the TEXT function to format the date and time into separate columns. For example, use =TEXT(A1,“mm/dd/yyyy”) for the date and =TEXT(A1,“hh:mm:ss”) for the time. This should work smoothly! You can also use custom formulas if you’re dealing with more complex data. For more details, check out this [how to separate date and time in excel](https://www.myexcelonline.com/blog/separate-date-and-time/) guide. ---
**Author:** ![zackh87](https://avatars.discourse-cdn.com/v4/letter/z/96bed5/32.png) [@zackh87](https://community.shotgridsoftware.com/u/zackh87)\ **Post date:** [December 20, 2024, 7:17am UTC](https://community.shotgridsoftware.com/t/importing-an-excel-weekly-status-report/19357/5 "2024-12-20T07:17:30Z")
there’s an easy way to make it all work within Shotgrid. ---
**Author:** ![Ricardo\_Musch](https://sea1.discourse-cdn.com/shotgunsoftware/user_avatar/community.shotgridsoftware.com/ricardo_musch/32/405_2.png) [@Ricardo\_Musch](https://community.shotgridsoftware.com/u/Ricardo_Musch)\ **Post date:** [December 24, 2024, 4:36pm UTC](https://community.shotgridsoftware.com/t/importing-an-excel-weekly-status-report/19357/6 "2024-12-24T16:36:00Z")
Are you saying you found a solution?