After loading the table file for the first time, a preview of the sheets appears. It can include headings, missing lines, excluded sheets, and merging multiple sheets.
When to use
Use table markup after receiving CSV/XLS/XLSX/XLSM if the service needs to understand the columns correctly.
Setting procedure
- Open the source with the table file.
- In the Table Layout section, check the row previews.
- Select heading mode: auto or manual line number.
- Specify the lines to be skipped, for example 1,2,5-12.
- Eliminate extra sheets or enable gluing of sheets if the structure is the same.
- Save the source and use it in your profile.
What to check
- In the preview, the first row of data is not taken as a header.
- Column names are readable without empty or duplicate keys.
- Sheets that should not be included are excluded.
Notes
- If the supplier changes the table format, enable structure change protection.
- Use sheet gluing only for sheets with a compatible structure.