# Keep column orders for lists when exporting to excel **URL:** \ **Category:** HubSpot Ideas\ **Tags:** segments\ **Created:** [December 4, 2019, 12:37pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555 "2019-12-04T12:37:47Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![hannaht123](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hannaht123/32/61905_2.png) [@hannaht123](https://community.hubspot.com/u/hannaht123)\ **Post date:** [December 4, 2019, 12:37pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/1 "2019-12-04T12:37:47Z")
When creating a contact list we set a particular order for the property coloumns to be arranged in. I.e. contact name, then email, then contact owner etc. You are also able to rearrange this via the pop up box when clicking to export. However, when the export to excel (csv) happens the order doesnt stay. So we then have to physically reorder in excel. When there’s around 15 columns this can be frustrating ---
**Author:** ![MagaliP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/magalip/32/10758_2.png) [@MagaliP](https://community.hubspot.com/u/MagaliP)\ **Post date:** [February 5, 2020, 4:10pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/2 "2020-02-05T16:10:41Z")
Hi, I encounter the same problem (I even have much more columns). I need to reorder them when they are exported to excel. I confirm this is frustrating (and time consuming, risk of error, column deletion etc to reorder everything :-)) ---
**Author:** ![louiseW](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/louisew/32/84083_2.png) [@louiseW](https://community.hubspot.com/u/louiseW)\ **Post date:** [February 7, 2020, 1:48pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/3 "2020-02-07T13:48:13Z")
Can I ask how you even order the columns within the CRM (before you export) - I am stuck on that stage! Thanks ---
**Author:** ![MagaliP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/magalip/32/10758_2.png) [@MagaliP](https://community.hubspot.com/u/MagaliP)\ **Post date:** [February 7, 2020, 1:59pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/4 "2020-02-07T13:59:12Z")
Hi I order the columns in the list. When you open it, click on Actions/Edit Columns. There, I select them in the order I want them to appear in the view (and in the export) or can change the order by drag and drop (select the block with 12 dots) and just move it up or down. Don’t forget to save. Hope I understood your question well. Magali ---
**Author:** ![louiseW](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/louisew/32/84083_2.png) [@louiseW](https://community.hubspot.com/u/louiseW)\ **Post date:** [February 7, 2020, 2:01pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/5 "2020-02-07T14:01:33Z")
And what do you do for deals? Thank you! Louise ---
**Author:** ![MagaliP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/magalip/32/10758_2.png) [@MagaliP](https://community.hubspot.com/u/MagaliP)\ **Post date:** [February 7, 2020, 2:25pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/6 "2020-02-07T14:25:36Z")
I just use Contacts for the moment. Cannot help you on this Magali ---
**Author:** ![hannaht123](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hannaht123/32/61905_2.png) [@hannaht123](https://community.hubspot.com/u/hannaht123)\ **Post date:** [February 7, 2020, 2:28pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/7 "2020-02-07T14:28:46Z")
Hi Ladies. Ah Magali i really hope they fix it soon! Louise the exact same process that Magali explained so well for re-ordering contacts is the same for deals 🙂 ---
**Author:** ![BastiSchuhl](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bastischuhl/32/42145_2.png) [@BastiSchuhl](https://community.hubspot.com/u/BastiSchuhl)\ **Post date:** [March 24, 2020, 11:23am UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/8 "2020-03-24T11:23:04Z")
@MagaliP @louiseW as @hannaht123 mentioned, the column editing for deals (and all object types: contacts, companies, deals) works the same. For deals, it’s essential to use the “Table” view though. Editing columns won’t be possible on the “Board” (Kanban") view. Hope this helps. ---
**Author:** ![CCasemore](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ccasemore/32/84023_2.png) [@CCasemore](https://community.hubspot.com/u/CCasemore)\ **Post date:** [June 8, 2020, 6:28pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/9 "2020-06-08T18:28:52Z")
This is critical, as we use HubSpot List exports for a number of Lead research activities that can’t be done as easily in HubSpot and reordering the columns again in the Excel export is annoying. We would appreciate if the export’s column order used the column order of its List. ---
**Author:** ![EricSGoldstein](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ericsgoldstein/32/77566_2.png) [@EricSGoldstein](https://community.hubspot.com/u/EricSGoldstein)\ **Post date:** [June 20, 2020, 9:33am UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/10 "2020-06-20T09:33:12Z")
I agree - this is strange that it loses the column order. ---
**Author:** ![NPLEVIN](https://avatars.discourse-cdn.com/v4/letter/n/ed655f/32.png) [@NPLEVIN](https://community.hubspot.com/u/NPLEVIN)\ **Post date:** [July 11, 2022, 6:37pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/11 "2022-07-11T18:37:57Z")
It takes forever to sort and reorder the data. Please add this feature. ---
**Author:** ![McKinney56](https://avatars.discourse-cdn.com/v4/letter/m/9de053/32.png) [@McKinney56](https://community.hubspot.com/u/McKinney56)\ **Post date:** [July 1, 2023, 5:33pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/12 "2023-07-01T17:33:56Z")
This is ridiculous that the columns don’t come out in the same order as the report in CRM. It is very time consuming to have to re-format the columns every time you want to pull a report into Excel. Who deteremines the order of the columns that come out into Excel? This should have been fixed by now for the price we are paying for the software. This has been reported as a probelm for over 4 years. ---
**Author:** ![MWogan](https://avatars.discourse-cdn.com/v4/letter/m/f0a364/32.png) [@MWogan](https://community.hubspot.com/u/MWogan)\ **Post date:** [July 20, 2023, 1:39pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/13 "2023-07-20T13:39:45Z")
Something that is definitely needed for exports! ---
**Author:** ![FionaW8](https://avatars.discourse-cdn.com/v4/letter/f/65b543/32.png) [@FionaW8](https://community.hubspot.com/u/FionaW8)\ **Post date:** [July 20, 2023, 1:46pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/14 "2023-07-20T13:46:21Z")
Definitely needed for exports! - makes being able to sort them within the CRM a bit pointless - as above it is very time-consuming to the re-order or pull out the individual columns of data needed for different purposes. Please sort this out! ---
**Author:** ![McKinney56](https://avatars.discourse-cdn.com/v4/letter/m/9de053/32.png) [@McKinney56](https://community.hubspot.com/u/McKinney56)\ **Post date:** [July 20, 2023, 3:07pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/15 "2023-07-20T15:07:28Z")
I don’t know why they don’t tell us this but the data exports in the order of your data columns not in the order of the report columns. So if you go in adjust your data columns to be in the same order as the report columns then it exports them correctly. ---
**Author:** ![DZeenberg](https://avatars.discourse-cdn.com/v4/letter/d/4da419/32.png) [@DZeenberg](https://community.hubspot.com/u/DZeenberg)\ **Post date:** [July 20, 2023, 3:12pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/16 "2023-07-20T15:12:12Z")
@McKinney56 where do you edit the data column order? ---
**Author:** ![McKinney56](https://avatars.discourse-cdn.com/v4/letter/m/9de053/32.png) [@McKinney56](https://community.hubspot.com/u/McKinney56)\ **Post date:** [July 20, 2023, 3:23pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/17 "2023-07-20T15:23:28Z")
Under the actions button (the same button you use to export the report) for the report the top option is customize. If you select that you see the report with two tabs at the top one is data and the other is visualization. Then if you click on the data tab you can adjust the order of the data columns in the Select Properties box on the left side of the screen. ---
**Author:** ![DZeenberg](https://avatars.discourse-cdn.com/v4/letter/d/4da419/32.png) [@DZeenberg](https://community.hubspot.com/u/DZeenberg)\ **Post date:** [July 20, 2023, 4:01pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/18 "2023-07-20T16:01:52Z")
I could be wrong but I don’t think this thread is in relation to a report or list, its in relation to the record grids. Actions drop-down does not include a Customize option. ![DZeenberg_0-1689868885935.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/4/4/44c20e50ba14dc2bb6d052169498f8ba16970218.png) ---
**Author:** ![McKinney56](https://avatars.discourse-cdn.com/v4/letter/m/9de053/32.png) [@McKinney56](https://community.hubspot.com/u/McKinney56)\ **Post date:** [July 20, 2023, 4:46pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/19 "2023-07-20T16:46:28Z")
It does for me. Maybe you don’t have the right authorization level. My problem was my reports were not exporting in the report format order and this is how I was instructed to fixed it and it has worked for me. ---
**Author:** ![DZeenberg](https://avatars.discourse-cdn.com/v4/letter/d/4da419/32.png) [@DZeenberg](https://community.hubspot.com/u/DZeenberg)\ **Post date:** [July 20, 2023, 5:05pm UTC](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555/20 "2023-07-20T17:05:52Z")
Well, i’m a super admin so that would be concerning. if anyone at Hubspot can chime in that’d be great because I don’t see this functionality on the contact, company grid level [Next page](https://community.hubspot.com/t/keep-column-orders-for-lists-when-exporting-to-excel/17555.md?page=2)