Export Settings

The example Excel template file defines how your result Excel files will look. In some cases, you can use additional settings to achieve other desired effects.

Header offset

Many Excel files have the header in row one, and the data start in row two. It is possible, though, to have rows above the header. This can be used to display a title of the Excel file, or some other information that will not change with the data.

To use this feature, create an example Excel file that looks like the Excel files you want to produce. Put the header row anywhere you want to, and the data and footer rows below that. The header can be on the first line, on the fifth line, or any other line you wish. The data you put above the header row will not be modified during the Excel export and will be included in your final Excel file as-is.

You must also configure the GoodGrids Excel export and specify the row where the header is found. If the header is found on the first row, then nothing else needs to be done. Otherwise, go to the config settings and click on the "Change header row" button. Enter the number of rows that are above the header row in the example Excel file.

If your header row is found on row 3, enter 2 in the header row offset. If it is on row 5, enter 4. If the header is in the first row, enter 0.

Input separator

Most of the time, CSV files contain values that are separated by commas. That's where the name comes from: Comma Separated Value. However, sometimes a different field delimiter is used. It can be a tab, semi-colon ; , pipe |, or anything else.

If you do not specify a separator, GoodGrids will guess. This works most of the time.